LPN splitting

Use this transaction to perform the following actions:

  • Split an LPN into one or several other LPNs. This means moving stock lines from an LPN to one or several other LPNs.

  • Generate stock change movements and create a stock change document in Sage X3.

Prerequisites

In Sage X3, perform the actions described below.

Functional prerequisites

Mobile Automation setup (FUNADCSEARCH)

Open: Setup > Stock > Mobile Automation setup

  1. Go to the Stock search section.

  2. Select the Container operation flow type.

  3. Define the stock search filters that you want to use in this transaction. You can define up to 8 filters. These stock search filters are the same for the LPN linking, LPN unlinking, and LPN splitting transactions.

In these transactions, these filters do not display in the order in which you have defined them in the Mobile Automation setup function. They always display in the following order: Location, Lot, Sublot, Serial number (when the management mode is Received/Issued), Status, Packing unit, PAC/STK conversion factor, Identifier 1 and Identifier 2, Custom field 1 and Custom field 2.

Web service prerequisites

  1. Open: Administration > Web services > Classic SOAP pools configuration

    Stop the web service pool.

  2. Import/export templates (GESAOE)

    Open: Setup > Usage > Imports / exports > Import/export templates

    Validate the CWSLPNO import template.

  3. Web services (GESAWE)

    Open: Development > Script dictionary > Scripts > Web services

    Publish the AOWSIMPORT web service.

  4. Open: Administration > Web services > Classic SOAP pools configuration

    Start the web service pool.

How to split an LPN

Open: LPN > LPN splitting

To split an LPN, enter information on 3 pages:

  • The initial page is used to select the LPN and the product to be assigned to the destination LPN. You can also enter the destination LPN and destination location on this page.
  • The second page is used to select the product stock lines. From this page, you can also perform the following actions:
    • Display the stock line details
    • Enter the exact quantity to split
  • The third page is used to validate the creation of the stock change document and validate the stock movement.

Operating mode

  1. On the initial page, check that the Change date and Site default values are correct.
  2. Scan, select or enter the License plate number to split.

  3. Scan, select or enter the Product.

  4. Scan, select or enter the Destination license plate number and the Destination location. This step is not a mandatory one. You can enter this information before creating the splitting.

  5. Tap Next to display the list of existing stock lines for the product. You can filter the list based on the selection filters displayed in the header. These filters are defined in the Mobile Automation setup function (FUNADCSEARCH). Refer to the Functional prerequisites.

  6. Select the checkbox for each stock line that you want to remove from the LPN. To access the stock line details, enter a smaller quantity, select the stock details, and tap the line.

  7. Tap Next when you have selected the stock lines and stock details to be removed from the LPN. You are automatically redirected to the initial page. The stock lines removed from the LPN are listed at the bottom of the screen. You are ready to complete one of the following actions:
    • Remove another product from the same LPN, if this LPN is not defined in the License plate number function (GESLPN) as a single-product managed LPN: Repeat steps 3 to 7.

    • Validate the creation of the stock change document: Go to step 8.

      If you have not yet entered the Destination license plate number and the Destination location in step 4, scan, select or enter this information which is mandatory to create the splitting.
    • Delete a line: Tap the delete icon.
  8. Tap Create to validate the stock change movement.

    • If you were able to proceed with the creation, the generated stock change number displays. The stock change document and its associated movements are created.

    • If you could not proceed with the creation, an error or information message displays.

      • Tap Go back to display the previous page.

      • Tap Cancel to delete all the stock changes.

Step by step

LPN splitting initial page

   

Enter the LPN splitting details.

  • The Change date defaults to today's date. You can change it until you tap Create, and only to an earlier date. This date applies to all the changes performed in the same document.
  • The Site defined in the Site screen displays automatically. You cannot modify it on the current page.
  • Scan, select or enter the License plate number to be split.
  • Scan, select or enter the Product code or the UPC code linked to the LPN. You can also search by X3 product description.

  • The Destination license plate number is not mandatory on this page. You can scan, select or enter it on this page, or just before taping on Create.

  • You can scan, select or enter the Destination location if the selected license plate number is not linked to any location. This information is not mandatory on this page. You can scan, select or enter it on this page, or just before taping on Create.

 


Tap Next to display the Select stock page.

LPN splitting - Select stock

Use this page to select the stock lines to be removed from the LPN.


The header displays the following information:

  • The selected LPN
  • The location linked to the LPN
  • The selected product code

The filters defined in the Mobile Automation setup function (FUNADCSEARCH) are displayed here. Use them to filter the list of stock lines.

The list of stock lines is displayed.

Each stock line displays the following information:

  • The quantity to be removed from the LPN, related to the quantity in stock, and the product code
  • Information linked to the filters displayed in the header. In this example, the current location and the lot number.

 

You can perform one of the following actions:

  • To remove the entire stock line, select the checkbox.

  • To remove a quantity smaller than the total quantity and select the stock details, tap the line. The next LPN splitting - Select stock page displays the stock details.

 

Tap Next to display the initial page with the stock lines you have selected to be removed from the LPN. You are ready to perform the following actions:

  • Remove another product from the same LPN and move it to the same destination LPN.

    You can move another product to the same destination LPN only if the LPN is not defined in the License plate number function (GESLPN) as a single-product managed LPN.
  • Create the stock change document and generate stock movements

LPN splitting - Select stock

When you tap a stock line, a page displays the stock details. You can enter a quantity smaller than the quantity in stock.

     

 
   
   
   
   
   
 

 

   
Update the quantity to remove.
   

Depending on how the product is managed, you might need to select the related stock details.
For example, if the product is managed by global serial numbers, you need to select the range of serial numbers to remove.

   
   
   
Keep or update the quantity to remove.

Select the Starting serial number. The Ending serial number is automatically displayed based on the quantity.

Only sequential serial numbers can be selected. The quantity you enter must be consistent with the range of serial numbers.
Tap the + icon to validate your selection and display a summary of the selected stock details.
     
   

 
   
   
   
   
   
   
   

A summary of the selected stock details is displayed. You can repeat the previous step:

  1. Add another quantity and another range of serial numbers.

  2. Tap the + icon to validate your selection.

   
 

When you have selected all the serial numbers to move, tap one of the following actions:

  • Cancel to cancel the entered information and go back to the previous LPN splitting - Select stock page.

  • Select to validate the entered information. The previous LPN splitting - Select stock page displays. The checkbox for the stock line is automatically selected for the requested quantity.

Create the stock change document and generate stock movements

When you have selected all the stock lines along with the quantity and stock details, tap Next to display the initial page with the selected stock lines.

   
   

The Destination license plate number is mandatory. It displays if you have entered it on the initial page, and you cannot change it. If not, you need to scan, select or enter it on this page.

The Destination location is mandatory. Scan, select or enter the Destination location if the selected destination license plate number is not yet linked to any location.

The list of splittings in progress displays at the bottom of the page and provides the following information:

  • Number of splittings in progress
  • List of product codes

You are ready to perform one of the following actions:

  • Move another product from the same LPN to the same destination LPN. Repeat the same steps as defined previously.

  • Delete an operation: Tap the delete icon.

Tap Create when you have completed splitting your LPN and you are ready to validate the creation of the stock change document and generate the stock movements.

     

 

 

 

A GraphQL payload is sent to Sage X3. The data of the payload is mapped with the CWSLPNO import template which is called by the import-type AOWSIMPORT SOAP web service.

A message displays the generated document number.

 

When the stock change document and the stock movements are created, you can display the result in the following Sage X3 functions:

  • License plate number operations function (GESLPNOPE)

  • Stock transactions inquiry (CONSSMV)

   
   

Limitations

The management rules are the same as in the License plate number operations function (GESLPNOPE). There is no consistency control of the quantities of the selected stock lines and the filling capacity of the selected destination LPN.